Pre-query Slicers allow you to set the slicer selections for specified slicers and parameters upon opening the tabulation, before the query is loaded. You can also create pre-query bookmarks to save multiple slicer selection combinations and apply them simultaneously.
Pre-query Slicers are available in Discover, Present, and Tabulate.
Note: this feature is not supported for SAP HANA or BW models containing predefined parameters.
Create Pre-Query Slicers
To create a pre-query slicer, open the slicer's Settings:
From the Other Settings tab, enable pre-query slicers (green arrow below):
Select Pre-Query Slicers
When you open a tabulation that contains pre-query slicers you will be presented with the Pre-query Slicer dialog (image below). The dialog presents all pre-query slicers in the report; each slicer can be searched and enabled or disabled as needed.
- To load the query, you must first select the required slicer values (purple highlight below).
- Save your slicer selections as bookmarks (yellow highlight below) so that you can quickly select 1 or more slicer values at once.
- To revert to the default slicer selection, click Restore Defaults (green highlight below).
Pre-Query Slicers from Multiple Sources
If your tabulation contains pre-query slicers from multiple sources, they will be arranged by data model, as in the image below.
Navigate the list of data models (yellow highlight below) to expose the slicers; be sure to make slicer selections for all slicers, or disable any slicers you don't want to affect the query.
Pre-Query Bookmarks
Bookmarks allow you to save multiple pre-query slicer selections (purple highlight above). You can then select the required bookmark to load multiple slicer selections into the query, rather than manually changing each of the slicers.
You can save multiple pre-query bookmarks pointing to different combinations of slicer selections. Bookmarks are not shareable and will only be seen by the current user.
Pre-query bookmarks are similar in concept to Presentation Bookmarks. However, they are only available for pre-query slicers, from the pre-query slicer dialog.
To create a pre-query slicer bookmark:
- Make the required slicer selections from the Pre-query Slicers dialog.
- Click the plus sign + next to the Bookmarks field; the slicer selections will be added to a drop-down list.
- Next time you open the Pre-query Slicers dialog, your bookmark will appear in the Bookmarks drop-down list. Select the required bookmark and click "Apply" to load the query.
To edit or delete a bookmark, select it from the list and click the edit icon.
- Click here to learn how to manage bookmarks.
Note: Pre-query slicer bookmarks are saved only to the current report for the current user.
Manage Pre-Query Slicers
When pre-query slicers are enabled in the query, the Pre-query Slicer button will appear in the Advanced Settings tab (purple highlight below):
Click this button to open the Pre-query Slicer dialog (as shown above), where you can add, edit, and delete pre-query slicer bookmarks.